Customer Accounts With Open Query Amounts

Report Name

Customer Accounts With Open Query Amounts

Objective

This report shows all Customer Accounts which have an amount in query, and the age of the associated query, to allow the pro-active management of open queries. The report shows if an account in dispute is on a credit control procedure, along with the account’s next expected invoice date, to allow focus to be given to these customers.

Expected Frequency

Can be run Daily, Weekly or Monthly

Period

Snapshot

Output File(s)

CUSTOMER ACCOUNTS WITH OPEN QUERY AMOUNTS_YYYYMMDD.csv

Output Fields

 Name Description
Account Number The CMP ID number of the account with an open query amount
Account Type The type of the account
Query Date The date the query was raised
Query Amount The monetary amount being queried
Days in Query How many days the amount has been in query
Invoice Number The ID number of the invoice associated with the queried amount
Query Number The ID number of the query
Workflow Number The number of the workflow associated with the query
Workflow Type The workflow type
Workflow Code The CMP code for the workflow associated with the query

Job Schedule Information

Schedule: As required; can be run Daily, Weekly or Monthly